EDA Update

Dataset statistics

Number of variables	17
Number of observations	840520
Missing cells	587717
Missing cells (%)	4.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	613.6 MiB
Average record size in memory	765.5 B

Variable types

Numeric	8
Categorical	9

Alerts

`FechaHecho` has a high cardinality: 2341 distinct values	High cardinality
`Delito` has a high cardinality: 349 distinct values	High cardinality
`ColoniaHechos` has a high cardinality: 2009 distinct values	High cardinality
`AlcaldiaHechos` has a high cardinality: 459 distinct values	High cardinality
`df_index` is highly correlated with `idCarpeta` and 1 other fields	High correlation
`idCarpeta` is highly correlated with `df_index` and 1 other fields	High correlation
`Año_hecho` is highly correlated with `df_index` and 1 other fields	High correlation
`df_index` is highly correlated with `idCarpeta` and 1 other fields	High correlation
`idCarpeta` is highly correlated with `df_index` and 1 other fields	High correlation
`Año_hecho` is highly correlated with `df_index` and 1 other fields	High correlation
`df_index` is highly correlated with `idCarpeta` and 1 other fields	High correlation
`idCarpeta` is highly correlated with `df_index` and 1 other fields	High correlation
`Año_hecho` is highly correlated with `df_index` and 1 other fields	High correlation
`CalidadJuridica` is highly correlated with `TipoPersona`	High correlation
`TipoPersona` is highly correlated with `CalidadJuridica`	High correlation
`df_index` is highly correlated with `dia_hechos` and 2 other fields	High correlation
`dia_hechos` is highly correlated with `df_index` and 1 other fields	High correlation
`Mes_hecho` is highly correlated with `df_index` and 1 other fields	High correlation
`Año_hecho` is highly correlated with `df_index`	High correlation
`CalidadJuridica` is highly correlated with `Categoria` and 1 other fields	High correlation
`Categoria` is highly correlated with `CalidadJuridica`	High correlation
`TipoPersona` is highly correlated with `CalidadJuridica`	High correlation
`longitud` is highly correlated with `latitud`	High correlation
`latitud` is highly correlated with `longitud`	High correlation
`ColoniaHechos` has 38296 (4.6%) missing values	Missing
`Sexo` has 161205 (19.2%) missing values	Missing
`Edad` has 302781 (36.0%) missing values	Missing
`longitud` has 38086 (4.5%) missing values	Missing
`latitud` has 38084 (4.5%) missing values	Missing
`idCarpeta` is highly skewed (γ1 = 24.97368042)	Skewed
`df_index` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`HoraHecho` has 11988 (1.4%) zeros	Zeros

Reproduction

Analysis started	2022-09-29 00:34:59.411032
Analysis finished	2022-09-29 00:37:45.000825
Duration	2 minutes and 45.59 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	840520
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	422872.4134

Minimum	0
Maximum	845622
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	42307.95
Q1	211492.75
median	422873
Q3	634294.25
95-th percentile	803323.05
Maximum	845622
Range	845622
Interquartile range (IQR)	422801.5

Descriptive statistics

Standard deviation	244095.7537
Coefficient of variation (CV)	0.5772326262
Kurtosis	-1.199840828
Mean	422872.4134
Median Absolute Deviation (MAD)	211401
Skewness	-0.0003155930762
Sum	3.554327209 × 10¹¹
Variance	5.958273699 × 10¹⁰
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
563797	1	< 0.1%
563787	1	< 0.1%
563788	1	< 0.1%
563789	1	< 0.1%
563790	1	< 0.1%
563791	1	< 0.1%
563792	1	< 0.1%
563793	1	< 0.1%
563794	1	< 0.1%
Other values (840510)	840510	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
845622	1	< 0.1%
845621	1	< 0.1%
845620	1	< 0.1%
845619	1	< 0.1%
845618	1	< 0.1%
845617	1	< 0.1%
845615	1	< 0.1%
845614	1	< 0.1%
845613	1	< 0.1%
845612	1	< 0.1%

idCarpeta
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	785490
Distinct (%)	93.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8770736.091

Minimum	8118324
Maximum	84881009
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	8118324
5-th percentile	8365695.95
Q1	8537366.75
median	8767879.5
Q3	9001345.5
95-th percentile	9182364.05
Maximum	84881009
Range	76762685
Interquartile range (IQR)	463978.75

Descriptive statistics

Standard deviation	275971.2562
Coefficient of variation (CV)	0.03146500514
Kurtosis	6881.404711
Mean	8770736.091
Median Absolute Deviation (MAD)	232084.5
Skewness	24.97368042
Sum	7.371979099 × 10¹²
Variance	7.616013424 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9125284	26	< 0.1%
9057330	22	< 0.1%
8718889	19	< 0.1%
8929524	17	< 0.1%
9124498	16	< 0.1%
9075349	15	< 0.1%
8406552	15	< 0.1%
9059545	14	< 0.1%
9119601	13	< 0.1%
8808098	13	< 0.1%
Other values (785480)	840350	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8118324	1	< 0.1%
8236085	1	< 0.1%
8312585	1	< 0.1%
8322418	1	< 0.1%
8322419	1	< 0.1%
8322420	1	< 0.1%
8322421	1	< 0.1%
8322422	1	< 0.1%
8322425	1	< 0.1%
8322426	1	< 0.1%

Value	Count	Frequency (%)
84881009	1	< 0.1%
9226877	1	< 0.1%
9226876	1	< 0.1%
9226875	1	< 0.1%
9226874	1	< 0.1%
9226873	1	< 0.1%
9226872	1	< 0.1%
9226871	1	< 0.1%
9226870	1	< 0.1%
9226869	1	< 0.1%

dia_hechos
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	343
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	6.059449378

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.436624173
Coefficient of variation (CV)	0.5671512309
Kurtosis	-1.179701614
Mean	6.059449378
Median Absolute Deviation (MAD)	3
Skewness	0.1868111753
Sum	5091010
Variance	11.81038571
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
3	87183	10.4%
1	80659	9.6%
2	80104	9.5%
5	79526	9.5%
4	75365	9.0%
6	74401	8.9%
8	62318	7.4%
10	61394	7.3%
9	60117	7.2%
11	60069	7.1%
Other values (2)	119041	14.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	80659	9.6%
2	80104	9.5%
3	87183	10.4%
4	75365	9.0%
5	79526	9.5%
6	74401	8.9%
7	59938	7.1%
8	62318	7.4%
9	60117	7.2%
10	61394	7.3%

Value	Count	Frequency (%)
12	59103	7.0%
11	60069	7.1%
10	61394	7.3%
9	60117	7.2%
8	62318	7.4%
7	59938	7.1%
6	74401	8.9%
5	79526	9.5%
4	75365	9.0%
3	87183	10.4%

Mes_hecho
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	343
Missing (%)	< 0.1%
Memory size	50.7 MiB

Marzo	87183
Enero	80659
Febrero	80104
Mayo	79526
Abril	75365
Other values (7)	437340

Length

Max length	10
Median length	9
Mean length	6.241477689
Min length	4

Characters and Unicode

Total characters	5243946
Distinct characters	27
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Agosto
2nd row	Diciembre
3rd row	Diciembre
4th row	Enero
5th row	Enero

Common Values

Value	Count	Frequency (%)
Marzo	87183	10.4%
Enero	80659	9.6%
Febrero	80104	9.5%
Mayo	79526	9.5%
Abril	75365	9.0%
Junio	74401	8.9%
Agosto	62318	7.4%
Octubre	61394	7.3%
Septiembre	60117	7.2%
Noviembre	60069	7.1%
Other values (2)	119041	14.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
marzo	87183	10.4%
enero	80659	9.6%
febrero	80104	9.5%
mayo	79526	9.5%
abril	75365	9.0%
junio	74401	8.9%
agosto	62318	7.4%
octubre	61394	7.3%
septiembre	60117	7.2%
noviembre	60069	7.1%
Other values (2)	119041	14.2%

Most occurring characters

Value	Count	Frequency (%)
e	720956	13.7%
o	646516	12.3%
r	644098	12.3%
i	448096	8.5%
b	396152	7.6%
u	195733	3.7%
t	183829	3.5%
m	179289	3.4%
M	166709	3.2%
a	166709	3.2%
Other values (17)	1495859	28.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4403769	84.0%
Uppercase Letter	840177	16.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	720956	16.4%
o	646516	14.7%
r	644098	14.6%
i	448096	10.2%
b	396152	9.0%
u	195733	4.4%
t	183829	4.2%
m	179289	4.1%
a	166709	3.8%
n	155060	3.5%
Other values (8)	667331	15.2%

Uppercase Letter

Value	Count	Frequency (%)
M	166709	19.8%
A	137683	16.4%
J	134339	16.0%
E	80659	9.6%
F	80104	9.5%
O	61394	7.3%
S	60117	7.2%
N	60069	7.1%
D	59103	7.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5243946	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	720956	13.7%
o	646516	12.3%
r	644098	12.3%
i	448096	8.5%
b	396152	7.6%
u	195733	3.7%
t	183829	3.5%
m	179289	3.4%
M	166709	3.2%
a	166709	3.2%
Other values (17)	1495859	28.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5243946	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	720956	13.7%
o	646516	12.3%
r	644098	12.3%
i	448096	8.5%
b	396152	7.6%
u	195733	3.7%
t	183829	3.5%
m	179289	3.4%
M	166709	3.2%
a	166709	3.2%
Other values (17)	1495859	28.5%

Año_hecho
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	343
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	2020.168312

Minimum	2016
Maximum	2022
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	2016
5-th percentile	2019
Q1	2019
median	2020
Q3	2021
95-th percentile	2022
Maximum	2022
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.110175728
Coefficient of variation (CV)	0.0005495461548
Kurtosis	-0.6204537957
Mean	2020.168312
Median Absolute Deviation (MAD)	1
Skewness	-0.004506048516
Sum	1697298952
Variance	1.232490147
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2019	260515	31.0%
2021	233266	27.8%
2020	213883	25.4%
2022	110035	13.1%
2018	17631	2.1%
2017	3241	0.4%
2016	1606	0.2%
(Missing)	343	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2016	1606	0.2%
2017	3241	0.4%
2018	17631	2.1%
2019	260515	31.0%
2020	213883	25.4%
2021	233266	27.8%
2022	110035	13.1%

Value	Count	Frequency (%)
2022	110035	13.1%
2021	233266	27.8%
2020	213883	25.4%
2019	260515	31.0%
2018	17631	2.1%
2017	3241	0.4%
2016	1606	0.2%

FechaHecho
Categorical

HIGH CARDINALITY

Distinct	2341
Distinct (%)	0.3%
Missing	343
Missing (%)	< 0.1%
Memory size	53.7 MiB

01/01/2021	1199
01/01/2020	1114
01/04/2019	1030
15/03/2019	951
15/02/2019	948
Other values (2336)	834935

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	8401770
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	67 ?
Unique (%)	< 0.1%

Sample

1st row	29/08/2018
2nd row	15/12/2018
3rd row	22/12/2018
4th row	04/01/2019
5th row	03/01/2019

Common Values

Value	Count	Frequency (%)
01/01/2021	1199	0.1%
01/01/2020	1114	0.1%
01/04/2019	1030	0.1%
15/03/2019	951	0.1%
15/02/2019	948	0.1%
01/03/2019	941	0.1%
01/02/2019	934	0.1%
15/05/2019	925	0.1%
01/07/2019	921	0.1%
01/08/2019	914	0.1%
Other values (2331)	830300	98.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
01/01/2021	1199	0.1%
01/01/2020	1114	0.1%
01/04/2019	1030	0.1%
15/03/2019	951	0.1%
15/02/2019	948	0.1%
01/03/2019	941	0.1%
01/02/2019	934	0.1%
15/05/2019	925	0.1%
01/07/2019	921	0.1%
01/08/2019	914	0.1%
Other values (2331)	830300	98.8%

Most occurring characters

Value	Count	Frequency (%)
0	2110064	25.1%
2	1998298	23.8%
/	1680354	20.0%
1	1219272	14.5%
9	398476	4.7%
3	208312	2.5%
5	165844	2.0%
8	162041	1.9%
6	157262	1.9%
4	156942	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	6721416	80.0%
Other Punctuation	1680354	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2110064	31.4%
2	1998298	29.7%
1	1219272	18.1%
9	398476	5.9%
3	208312	3.1%
5	165844	2.5%
8	162041	2.4%
6	157262	2.3%
4	156942	2.3%
7	144905	2.2%

Other Punctuation

Value	Count	Frequency (%)
/	1680354	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	8401770	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2110064	25.1%
2	1998298	23.8%
/	1680354	20.0%
1	1219272	14.5%
9	398476	4.7%
3	208312	2.5%
5	165844	2.0%
8	162041	1.9%
6	157262	1.9%
4	156942	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8401770	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2110064	25.1%
2	1998298	23.8%
/	1680354	20.0%
1	1219272	14.5%
9	398476	4.7%
3	208312	2.5%
5	165844	2.0%
8	162041	1.9%
6	157262	1.9%
4	156942	1.9%

HoraHecho
Real number (ℝ_≥0)

ZEROS

Distinct	1688
Distinct (%)	0.2%
Missing	333
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	47470.78861

Minimum	0
Maximum	86340
Zeros	11988
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	7200
Q1	35100
median	46800
Q3	64740
95-th percentile	79200
Maximum	86340
Range	86340
Interquartile range (IQR)	29640

Descriptive statistics

Standard deviation	21046.01066
Coefficient of variation (CV)	0.4433465563
Kurtosis	-0.5225063221
Mean	47470.78861
Median Absolute Deviation (MAD)	14400
Skewness	-0.2874631383
Sum	3.988433947 × 10¹⁰
Variance	442934564.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
43200	72177	8.6%
36000	31856	3.8%
39600	19059	2.3%
54000	18934	2.3%
50400	18414	2.2%
32400	18406	2.2%
57600	17106	2.0%
64800	16101	1.9%
46800	15839	1.9%
61200	15833	1.9%
Other values (1678)	596462	71.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11988	1.4%
1	7	< 0.1%
2	7	< 0.1%
3	7	< 0.1%
4	6	< 0.1%
5	7	< 0.1%
6	6	< 0.1%
7	6	< 0.1%
8	4	< 0.1%
9	5	< 0.1%

Value	Count	Frequency (%)
86340	238	< 0.1%
86280	82	< 0.1%
86220	48	< 0.1%
86160	42	< 0.1%
86100	485	0.1%
86040	32	< 0.1%
85980	38	< 0.1%
85920	40	< 0.1%
85860	35	< 0.1%
85800	1102	0.1%

Delito
Categorical

HIGH CARDINALITY

Distinct	349
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	72.0 MiB

VIOLENCIA FAMILIAR	114006
FRAUDE	59069
AMENAZAS	55926
ROBO DE OBJETOS	41868
ROBO A TRANSEUNTE EN VIA PUBLICA CON VIOLENCIA	38160
Other values (344)	531491

Length

Max length	213
Median length	91
Mean length	30.21143935
Min length	4

Characters and Unicode

Total characters	25393319
Distinct characters	47
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	20 ?
Unique (%)	< 0.1%

Sample

1st row	FRAUDE
2nd row	PRODUCCIÓN, IMPRESIÓN, ENAJENACIÓN, DISTRIBUCIÓN, ALTERACIÓN O FALSIFICACIÓN DE TÍTULOS AL PORTADOR, DOCUMENTOS DE CRÉDITO PÚBLICOS O VALES DE CANJE
3rd row	ROBO A TRANSEUNTE SALIENDO DEL BANCO CON VIOLENCIA
4th row	ROBO DE VEHICULO DE SERVICIO PARTICULAR SIN VIOLENCIA
5th row	ROBO DE MOTOCICLETA SIN VIOLENCIA

Common Values

Value	Count	Frequency (%)
VIOLENCIA FAMILIAR	114006	13.6%
FRAUDE	59069	7.0%
AMENAZAS	55926	6.7%
ROBO DE OBJETOS	41868	5.0%
ROBO A TRANSEUNTE EN VIA PUBLICA CON VIOLENCIA	38160	4.5%
ROBO A NEGOCIO SIN VIOLENCIA	29565	3.5%
ROBO DE ACCESORIOS DE AUTO	27498	3.3%
ROBO DE OBJETOS DEL INTERIOR DE UN VEHICULO	21302	2.5%
ROBO A NEGOCIO CON VIOLENCIA	20492	2.4%
ROBO DE VEHICULO DE SERVICIO PARTICULAR SIN VIOLENCIA	17196	2.0%
Other values (339)	415438	49.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	438736	11.2%
violencia	331576	8.5%
robo	331502	8.5%
a	227978	5.8%
con	116526	3.0%
familiar	114006	2.9%
sin	106548	2.7%
en	99102	2.5%
por	84513	2.2%
negocio	71650	1.8%
Other values (481)	1981454	50.8%

Most occurring characters

Value	Count	Frequency (%)
	3063103	12.1%
O	2784411	11.0%
A	2453243	9.7%
I	2384482	9.4%
E	2283658	9.0%
N	1699843	6.7%
R	1369313	5.4%
C	1358867	5.4%
S	1112839	4.4%
L	1086493	4.3%
Other values (37)	5797067	22.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	22177904	87.3%
Space Separator	3063103	12.1%
Other Punctuation	88998	0.4%
Open Punctuation	21229	0.1%
Close Punctuation	21229	0.1%
Decimal Number	11472	< 0.1%
Math Symbol	8823	< 0.1%
Control	561	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	2784411	12.6%
A	2453243	11.1%
I	2384482	10.8%
E	2283658	10.3%
N	1699843	7.7%
R	1369313	6.2%
C	1358867	6.1%
S	1112839	5.0%
L	1086493	4.9%
D	1007277	4.5%
Other values (21)	4637478	20.9%

Decimal Number

Value	Count	Frequency (%)
0	5882	51.3%
9	2941	25.6%
3	1553	13.5%
1	952	8.3%
8	144	1.3%

Other Punctuation

Value	Count	Frequency (%)
,	75709	85.1%
/	12887	14.5%
.	402	0.5%

Math Symbol

Value	Count	Frequency (%)
<	2941	33.3%
+	2941	33.3%
>	2941	33.3%

Control

Value	Count	Frequency (%)
	392	69.9%
	169	30.1%

Space Separator

Value	Count	Frequency (%)
	3063103	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	21229	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	21229	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	22177904	87.3%
Common	3215415	12.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	2784411	12.6%
A	2453243	11.1%
I	2384482	10.8%
E	2283658	10.3%
N	1699843	7.7%
R	1369313	6.2%
C	1358867	6.1%
S	1112839	5.0%
L	1086493	4.9%
D	1007277	4.5%
Other values (21)	4637478	20.9%

Common

Value	Count	Frequency (%)
	3063103	95.3%
,	75709	2.4%
(	21229	0.7%
)	21229	0.7%
/	12887	0.4%
0	5882	0.2%
<	2941	0.1%
+	2941	0.1%
9	2941	0.1%
>	2941	0.1%
Other values (6)	3612	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25198588	99.2%
None	194731	0.8%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3063103	12.2%
O	2784411	11.0%
A	2453243	9.7%
I	2384482	9.5%
E	2283658	9.1%
N	1699843	6.7%
R	1369313	5.4%
C	1358867	5.4%
S	1112839	4.4%
L	1086493	4.3%
Other values (28)	5602336	22.2%

None

Value	Count	Frequency (%)
Ó	95220	48.9%
Ñ	35884	18.4%
Ú	22144	11.4%
Á	14780	7.6%
Í	11704	6.0%
É	10936	5.6%
Ã	3502	1.8%
	392	0.2%
	169	0.1%

CalidadJuridica
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Memory size	58.9 MiB

VICTIMA Y DENUNCIANTE	542855
OFENDIDO	132812
VICTIMA	96709
LESIONADO	24280
AGRAVIADO	18673
Other values (2)	25190

Length

Max length	22
Median length	21
Mean length	16.45526276
Min length	7

Characters and Unicode

Total characters	13830961
Distinct characters	18
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	OFENDIDO
2nd row	VICTIMA Y DENUNCIANTE
3rd row	VICTIMA Y DENUNCIANTE
4th row	VICTIMA Y DENUNCIANTE
5th row	VICTIMA

Common Values

Value	Count	Frequency (%)
VICTIMA Y DENUNCIANTE	542855	64.6%
OFENDIDO	132812	15.8%
VICTIMA	96709	11.5%
LESIONADO	24280	2.9%
AGRAVIADO	18673	2.2%
CADAVER	16614	2.0%
OFENDIDO Y DENUNCIANTE	8576	1.0%
(Missing)	1	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
victima	639564	32.9%
y	551431	28.4%
denunciante	551431	28.4%
ofendido	141388	7.3%
lesionado	24280	1.2%
agraviado	18673	1.0%
cadaver	16614	0.9%

Most occurring characters

Value	Count	Frequency (%)
I	2014900	14.6%
N	1819961	13.2%
A	1304522	9.4%
E	1285144	9.3%
C	1207609	8.7%
T	1190995	8.6%
	1102862	8.0%
D	893774	6.5%
V	674851	4.9%
M	639564	4.6%
Other values (8)	1696779	12.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	12728099	92.0%
Space Separator	1102862	8.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	2014900	15.8%
N	1819961	14.3%
A	1304522	10.2%
E	1285144	10.1%
C	1207609	9.5%
T	1190995	9.4%
D	893774	7.0%
V	674851	5.3%
M	639564	5.0%
Y	551431	4.3%
Other values (7)	1145348	9.0%

Space Separator

Value	Count	Frequency (%)
	1102862	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12728099	92.0%
Common	1102862	8.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	2014900	15.8%
N	1819961	14.3%
A	1304522	10.2%
E	1285144	10.1%
C	1207609	9.5%
T	1190995	9.4%
D	893774	7.0%
V	674851	5.3%
M	639564	5.0%
Y	551431	4.3%
Other values (7)	1145348	9.0%

Common

Value	Count	Frequency (%)
	1102862	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	13830961	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	2014900	14.6%
N	1819961	13.2%
A	1304522	9.4%
E	1285144	9.3%
C	1207609	8.7%
T	1190995	8.6%
	1102862	8.0%
D	893774	6.5%
V	674851	4.9%
M	639564	4.6%
Other values (8)	1696779	12.3%

Categoria
Categorical

HIGH CORRELATION

Distinct	20
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	67.7 MiB

DELITO DE BAJO IMPACTO	683259
ROBO A TRANSEUNTE EN VÍA PÚBLICA CON Y SIN VIOLENCIA	44096
ROBO DE VEHÍCULO CON Y SIN VIOLENCIA	34601
ROBO A NEGOCIO CON VIOLENCIA	22591
HECHO NO DELICTIVO	13723
Other values (15)	42250

Length

Max length	61
Median length	22
Mean length	24.92923547
Min length	9

Characters and Unicode

Total characters	20953521
Distinct characters	34
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DELITO DE BAJO IMPACTO
2nd row	DELITO DE BAJO IMPACTO
3rd row	ROBO A CUENTAHABIENTE SALIENDO DEL CAJERO CON VIOLENCIA
4th row	ROBO DE VEHÍCULO CON Y SIN VIOLENCIA
5th row	ROBO DE VEHÍCULO CON Y SIN VIOLENCIA

Common Values

Value	Count	Frequency (%)
DELITO DE BAJO IMPACTO	683259	81.3%
ROBO A TRANSEUNTE EN VÍA PÚBLICA CON Y SIN VIOLENCIA	44096	5.2%
ROBO DE VEHÍCULO CON Y SIN VIOLENCIA	34601	4.1%
ROBO A NEGOCIO CON VIOLENCIA	22591	2.7%
HECHO NO DELICTIVO	13723	1.6%
ROBO A REPARTIDOR CON Y SIN VIOLENCIA	10191	1.2%
VIOLACIÓN	6396	0.8%
ROBO A PASAJERO A BORDO DEL METRO CON Y SIN VIOLENCIA	5640	0.7%
HOMICIDIO DOLOSO	5388	0.6%
LESIONES DOLOSAS POR DISPARO DE ARMA DE FUEGO	4528	0.5%
Other values (10)	10107	1.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	731566	19.0%
delito	683259	17.8%
bajo	683259	17.8%
impacto	683259	17.8%
con	126896	3.3%
robo	126896	3.3%
violencia	126896	3.3%
a	101467	2.6%
sin	99528	2.6%
y	99528	2.6%
Other values (37)	379862	9.9%

Most occurring characters

Value	Count	Frequency (%)
	3001896	14.3%
O	2791334	13.3%
I	1875548	9.0%
E	1816477	8.7%
A	1802226	8.6%
T	1493931	7.1%
D	1477064	7.0%
C	1089945	5.2%
L	933904	4.5%
B	871731	4.2%
Other values (24)	3799465	18.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	17942673	85.6%
Space Separator	3001896	14.3%
Decimal Number	3837	< 0.1%
Math Symbol	3597	< 0.1%
Control	1518	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	2791334	15.6%
I	1875548	10.5%
E	1816477	10.1%
A	1802226	10.0%
T	1493931	8.3%
D	1477064	8.2%
C	1089945	6.1%
L	933904	5.2%
B	871731	4.9%
P	757722	4.2%
Other values (16)	3032791	16.9%

Decimal Number

Value	Count	Frequency (%)
0	2398	62.5%
9	1199	31.2%
3	240	6.3%

Math Symbol

Value	Count	Frequency (%)
>	1199	33.3%
<	1199	33.3%
+	1199	33.3%

Space Separator

Value	Count	Frequency (%)
	3001896	100.0%

Control

Value	Count	Frequency (%)
	1518	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	17942673	85.6%
Common	3010848	14.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	2791334	15.6%
I	1875548	10.5%
E	1816477	10.1%
A	1802226	10.0%
T	1493931	8.3%
D	1477064	8.2%
C	1089945	6.1%
L	933904	5.2%
B	871731	4.9%
P	757722	4.2%
Other values (16)	3032791	16.9%

Common

Value	Count	Frequency (%)
	3001896	99.7%
0	2398	0.1%
	1518	0.1%
>	1199	< 0.1%
<	1199	< 0.1%
+	1199	< 0.1%
9	1199	< 0.1%
3	240	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20817951	99.4%
None	135570	0.6%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	3001896	14.4%
O	2791334	13.4%
I	1875548	9.0%
E	1816477	8.7%
A	1802226	8.7%
T	1493931	7.2%
D	1477064	7.1%
C	1089945	5.2%
L	933904	4.5%
B	871731	4.2%
Other values (19)	3663895	17.6%

None

Value	Count	Frequency (%)
Í	78697	58.0%
Ú	44096	32.5%
Ó	8542	6.3%
Ã	2717	2.0%
	1518	1.1%

ColoniaHechos
Categorical

HIGH CARDINALITY
MISSING

Distinct	2009
Distinct (%)	0.3%
Missing	38296
Missing (%)	4.6%
Memory size	61.9 MiB

CENTRO	23294
DOCTORES	14307
DEL VALLE CENTRO	10261
ROMA NORTE	8594
MORELOS	7944
Other values (2004)	737824

Length

Max length	64
Median length	48
Mean length	15.9869974
Min length	3

Characters and Unicode

Total characters	12825153
Distinct characters	75
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	38 ?
Unique (%)	< 0.1%

Sample

1st row	GUADALUPE INN
2nd row	VICTORIA DE LAS DEMOCRACIAS
3rd row	COPILCO UNIVERSIDAD ISSSTE
4th row	AGRÍCOLA PANTITLAN
5th row	PROGRESISTA

Common Values

Value	Count	Frequency (%)
CENTRO	23294	2.8%
DOCTORES	14307	1.7%
DEL VALLE CENTRO	10261	1.2%
ROMA NORTE	8594	1.0%
MORELOS	7944	0.9%
BUENAVISTA	7468	0.9%
NARVARTE	7287	0.9%
AGRÍCOLA ORIENTAL	6864	0.8%
POLANCO	6011	0.7%
JUÁREZ	6003	0.7%
Other values (1999)	704191	83.8%
(Missing)	38296	4.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	120803	6.1%
san	115981	5.9%
santa	56115	2.8%
centro	42950	2.2%
sección	38794	2.0%
la	37631	1.9%
del	34199	1.7%
lomas	24246	1.2%
el	23744	1.2%
los	20008	1.0%
Other values (1482)	1461001	74.0%

Most occurring characters

Value	Count	Frequency (%)
A	1751352	13.7%
	1173541	9.2%
E	1105412	8.6%
O	925676	7.2%
N	864683	6.7%
L	799489	6.2%
R	794380	6.2%
S	680468	5.3%
C	673732	5.3%
I	667978	5.2%
Other values (65)	3388442	26.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	11514381	89.8%
Space Separator	1173541	9.2%
Decimal Number	71817	0.6%
Lowercase Letter	14136	0.1%
Other Punctuation	13784	0.1%
Math Symbol	12147	0.1%
Dash Punctuation	8211	0.1%
Open Punctuation	7365	0.1%
Close Punctuation	7155	0.1%
Control	2448	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1751352	15.2%
E	1105412	9.6%
O	925676	8.0%
N	864683	7.5%
L	799489	6.9%
R	794380	6.9%
S	680468	5.9%
C	673732	5.9%
I	667978	5.8%
T	605965	5.3%
Other values (24)	2645246	23.0%

Lowercase Letter

Value	Count	Frequency (%)
a	1828	12.9%
o	1704	12.1%
i	1626	11.5%
l	1140	8.1%
e	1128	8.0%
s	988	7.0%
t	944	6.7%
u	878	6.2%
n	864	6.1%
c	796	5.6%
Other values (8)	2240	15.8%

Decimal Number

Value	Count	Frequency (%)
2	19200	26.7%
1	15987	22.3%
0	11396	15.9%
3	9023	12.6%
9	5639	7.9%
4	2835	3.9%
7	2692	3.7%
8	2675	3.7%
5	1899	2.6%
6	471	0.7%

Other Punctuation

Value	Count	Frequency (%)
.	13274	96.3%
/	269	2.0%
?	241	1.7%

Math Symbol

Value	Count	Frequency (%)
>	4049	33.3%
+	4049	33.3%
<	4049	33.3%

Control

Value	Count	Frequency (%)
	1494	61.0%
	954	39.0%

Space Separator

Value	Count	Frequency (%)
	1173541	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	8211	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	7365	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	7155	100.0%

Other Symbol

Value	Count	Frequency (%)
°	168	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11528517	89.9%
Common	1296636	10.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1751352	15.2%
E	1105412	9.6%
O	925676	8.0%
N	864683	7.5%
L	799489	6.9%
R	794380	6.9%
S	680468	5.9%
C	673732	5.8%
I	667978	5.8%
T	605965	5.3%
Other values (42)	2659382	23.1%

Common

Value	Count	Frequency (%)
	1173541	90.5%
2	19200	1.5%
1	15987	1.2%
.	13274	1.0%
0	11396	0.9%
3	9023	0.7%
-	8211	0.6%
(	7365	0.6%
)	7155	0.6%
9	5639	0.4%
Other values (13)	25845	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12569355	98.0%
None	255798	2.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1751352	13.9%
	1173541	9.3%
E	1105412	8.8%
O	925676	7.4%
N	864683	6.9%
L	799489	6.4%
R	794380	6.3%
S	680468	5.4%
C	673732	5.4%
I	667978	5.3%
Other values (52)	3132644	24.9%

None

Value	Count	Frequency (%)
Ó	103456	40.4%
Á	54556	21.3%
É	37166	14.5%
Í	35216	13.8%
Ñ	9918	3.9%
Ã	6457	2.5%
Ú	6203	2.4%
	1494	0.6%
	954	0.4%
Ü	190	0.1%
Other values (3)	188	0.1%

AlcaldiaHechos
Categorical

HIGH CARDINALITY

Distinct	459
Distinct (%)	0.1%
Missing	1445
Missing (%)	0.2%
Memory size	55.3 MiB

IZTAPALAPA	128413
CUAUHTEMOC	121721
GUSTAVO A MADERO	86656
BENITO JUAREZ	62366
ALVARO OBREGON	60058
Other values (454)	379861

Length

Max length	38
Median length	35
Mean length	11.99198403
Min length	4

Characters and Unicode

Total characters	10062174
Distinct characters	32
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	195 ?
Unique (%)	< 0.1%

Sample

1st row	ALVARO OBREGON
2nd row	AZCAPOTZALCO
3rd row	COYOACAN
4th row	IZTACALCO
5th row	IZTAPALAPA

Common Values

Value	Count	Frequency (%)
IZTAPALAPA	128413	15.3%
CUAUHTEMOC	121721	14.5%
GUSTAVO A MADERO	86656	10.3%
BENITO JUAREZ	62366	7.4%
ALVARO OBREGON	60058	7.1%
COYOACAN	55522	6.6%
MIGUEL HIDALGO	52333	6.2%
TLALPAN	50498	6.0%
VENUSTIANO CARRANZA	48519	5.8%
AZCAPOTZALCO	40477	4.8%
Other values (449)	132512	15.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
iztapalapa	128413	9.8%
cuauhtemoc	121721	9.3%
madero	86662	6.6%
gustavo	86656	6.6%
a	86656	6.6%
juarez	63107	4.8%
benito	62366	4.8%
obregon	60060	4.6%
alvaro	60058	4.6%
coyoacan	55522	4.2%
Other values (532)	498095	38.0%

Most occurring characters

Value	Count	Frequency (%)
A	1937987	19.3%
O	971171	9.7%
C	671964	6.7%
T	628805	6.2%
L	606450	6.0%
E	564150	5.6%
U	536563	5.3%
	470246	4.7%
I	458959	4.6%
R	414324	4.1%
Other values (22)	2801555	27.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	9591901	95.3%
Space Separator	470246	4.7%
Lowercase Letter	16	< 0.1%
Other Punctuation	7	< 0.1%
Dash Punctuation	2	< 0.1%
Decimal Number	2	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1937987	20.2%
O	971171	10.1%
C	671964	7.0%
T	628805	6.6%
L	606450	6.3%
E	564150	5.9%
U	536563	5.6%
I	458959	4.8%
R	414324	4.3%
N	412192	4.3%
Other values (15)	2389336	24.9%

Lowercase Letter

Value	Count	Frequency (%)
u	8	50.0%
l	4	25.0%
m	4	25.0%

Space Separator

Value	Count	Frequency (%)
	470246	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	7	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2	100.0%

Decimal Number

Value	Count	Frequency (%)
2	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9591917	95.3%
Common	470257	4.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1937987	20.2%
O	971171	10.1%
C	671964	7.0%
T	628805	6.6%
L	606450	6.3%
E	564150	5.9%
U	536563	5.6%
I	458959	4.8%
R	414324	4.3%
N	412192	4.3%
Other values (18)	2389352	24.9%

Common

Value	Count	Frequency (%)
	470246	> 99.9%
.	7	< 0.1%
-	2	< 0.1%
2	2	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10062168	> 99.9%
None	6	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1937987	19.3%
O	971171	9.7%
C	671964	6.7%
T	628805	6.2%
L	606450	6.0%
E	564150	5.6%
U	536563	5.3%
	470246	4.7%
I	458959	4.6%
R	414324	4.1%
Other values (21)	2801549	27.8%

None

Value	Count	Frequency (%)
Ñ	6	100.0%

Sexo
Categorical

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	161205
Missing (%)	19.2%
Memory size	47.4 MiB

Masculino	361936
Femenino	317379

Length

Max length	9
Median length	9
Mean length	8.532795537
Min length	8

Characters and Unicode

Total characters	5796456
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Masculino
2nd row	Femenino
3rd row	Masculino
4th row	Masculino
5th row	Masculino

Common Values

Value	Count	Frequency (%)
Masculino	361936	43.1%
Femenino	317379	37.8%
(Missing)	161205	19.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
masculino	361936	53.3%
femenino	317379	46.7%

Most occurring characters

Value	Count	Frequency (%)
n	996694	17.2%
i	679315	11.7%
o	679315	11.7%
e	634758	11.0%
M	361936	6.2%
a	361936	6.2%
s	361936	6.2%
c	361936	6.2%
u	361936	6.2%
l	361936	6.2%
Other values (2)	634758	11.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5117141	88.3%
Uppercase Letter	679315	11.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	996694	19.5%
i	679315	13.3%
o	679315	13.3%
e	634758	12.4%
a	361936	7.1%
s	361936	7.1%
c	361936	7.1%
u	361936	7.1%
l	361936	7.1%
m	317379	6.2%

Uppercase Letter

Value	Count	Frequency (%)
M	361936	53.3%
F	317379	46.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5796456	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	996694	17.2%
i	679315	11.7%
o	679315	11.7%
e	634758	11.0%
M	361936	6.2%
a	361936	6.2%
s	361936	6.2%
c	361936	6.2%
u	361936	6.2%
l	361936	6.2%
Other values (2)	634758	11.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5796456	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	996694	17.2%
i	679315	11.7%
o	679315	11.7%
e	634758	11.0%
M	361936	6.2%
a	361936	6.2%
s	361936	6.2%
c	361936	6.2%
u	361936	6.2%
l	361936	6.2%
Other values (2)	634758	11.0%

Edad
Real number (ℝ_≥0)

MISSING

Distinct	112
Distinct (%)	< 0.1%
Missing	302781
Missing (%)	36.0%
Infinite	0
Infinite (%)	0.0%
Mean	38.84040399

Minimum	0
Maximum	369
Zeros	1873
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	0
5-th percentile	15
Q1	27
median	37
Q3	49
95-th percentile	68
Maximum	369
Range	369
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	16.27148541
Coefficient of variation (CV)	0.4189319302
Kurtosis	0.3442313976
Mean	38.84040399
Median Absolute Deviation (MAD)	11
Skewness	0.3889202799
Sum	20886000
Variance	264.7612375
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	14712	1.8%
28	14484	1.7%
29	14132	1.7%
27	14039	1.7%
31	13913	1.7%
32	13869	1.7%
35	13816	1.6%
26	13708	1.6%
33	13676	1.6%
34	13400	1.6%
Other values (102)	397990	47.4%
(Missing)	302781	36.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1873	0.2%
1	820	0.1%
2	1036	0.1%
3	1477	0.2%
4	1601	0.2%
5	1604	0.2%
6	1595	0.2%
7	1539	0.2%
8	1582	0.2%
9	1557	0.2%

Value	Count	Frequency (%)
369	1	< 0.1%
258	1	< 0.1%
120	1	< 0.1%
114	1	< 0.1%
111	1	< 0.1%
110	1	< 0.1%
107	1	< 0.1%
104	2	< 0.1%
103	2	< 0.1%
102	2	< 0.1%

TipoPersona
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	6114
Missing (%)	0.7%
Memory size	50.2 MiB

FISICA	659630
MORAL	174776

Length

Max length	6
Median length	6
Mean length	5.790538419
Min length	5

Characters and Unicode

Total characters	4831660
Distinct characters	9
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FISICA
2nd row	FISICA
3rd row	FISICA
4th row	FISICA
5th row	FISICA

Common Values

Value	Count	Frequency (%)
FISICA	659630	78.5%
MORAL	174776	20.8%
(Missing)	6114	0.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
fisica	659630	79.1%
moral	174776	20.9%

Most occurring characters

Value	Count	Frequency (%)
I	1319260	27.3%
A	834406	17.3%
F	659630	13.7%
S	659630	13.7%
C	659630	13.7%
M	174776	3.6%
O	174776	3.6%
R	174776	3.6%
L	174776	3.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	4831660	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
I	1319260	27.3%
A	834406	17.3%
F	659630	13.7%
S	659630	13.7%
C	659630	13.7%
M	174776	3.6%
O	174776	3.6%
R	174776	3.6%
L	174776	3.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4831660	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
I	1319260	27.3%
A	834406	17.3%
F	659630	13.7%
S	659630	13.7%
C	659630	13.7%
M	174776	3.6%
O	174776	3.6%
R	174776	3.6%
L	174776	3.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4831660	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
I	1319260	27.3%
A	834406	17.3%
F	659630	13.7%
S	659630	13.7%
C	659630	13.7%
M	174776	3.6%
O	174776	3.6%
R	174776	3.6%
L	174776	3.6%

longitud
Real number (ℝ)

HIGH CORRELATION
MISSING

Distinct	537438
Distinct (%)	67.0%
Missing	38086
Missing (%)	4.5%
Infinite	0
Infinite (%)	0.0%
Mean	-99.13624301

Minimum	-99.34235742
Maximum	-98.94685791
Zeros	0
Zeros (%)	0.0%
Negative	802434
Negative (%)	95.5%
Memory size	6.4 MiB

Quantile statistics

Minimum	-99.34235742
5-th percentile	-99.23663774
Q1	-99.17634
median	-99.14080247
Q3	-99.0961978
95-th percentile	-99.0249524
Maximum	-98.94685791
Range	0.3954995182
Interquartile range (IQR)	0.08014220351

Descriptive statistics

Standard deviation	0.06199454958
Coefficient of variation (CV)	-0.000625346974
Kurtosis	-0.008547327256
Mean	-99.13624301
Median Absolute Deviation (MAD)	0.03992568978
Skewness	0.09276759513
Sum	-79550292.02
Variance	0.003843324178
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-99.14957	255	< 0.1%
-99.14838	179	< 0.1%
-99.1446389	160	< 0.1%
-99.0905297	143	< 0.1%
-99.14792	140	< 0.1%
-99.14717	119	< 0.1%
-99.14133	113	< 0.1%
-99.15316	109	< 0.1%
-99.14544	90	< 0.1%
-99.14512	90	< 0.1%
Other values (537428)	801036	95.3%
(Missing)	38086	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-99.34235742	1	< 0.1%
-99.34146881	1	< 0.1%
-99.34145294	1	< 0.1%
-99.34135616	1	< 0.1%
-99.3413415	1	< 0.1%
-99.34125517	1	< 0.1%
-99.34121132	1	< 0.1%
-99.34072	1	< 0.1%
-99.3405354	2	< 0.1%
-99.34024	1	< 0.1%

Value	Count	Frequency (%)
-98.94685791	1	< 0.1%
-98.94737408	1	< 0.1%
-98.94771605	1	< 0.1%
-98.94780786	1	< 0.1%
-98.94808643	5	< 0.1%
-98.94813	2	< 0.1%
-98.94817114	1	< 0.1%
-98.94832	1	< 0.1%
-98.9483875	1	< 0.1%
-98.94854777	1	< 0.1%

latitud
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	540191
Distinct (%)	67.3%
Missing	38084
Missing (%)	4.5%
Infinite	0
Infinite (%)	0.0%
Mean	19.38518279

Minimum	19.12636062
Maximum	19.5833333
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.4 MiB

Quantile statistics

Minimum	19.12636062
5-th percentile	19.26385
Q1	19.33520005
median	19.38677639
Q3	19.43816702
95-th percentile	19.49446597
Maximum	19.5833333
Range	0.4569726806
Interquartile range (IQR)	0.102966974

Descriptive statistics

Standard deviation	0.07192627544
Coefficient of variation (CV)	0.003710373857
Kurtosis	-0.2653446445
Mean	19.38518279
Median Absolute Deviation (MAD)	0.05146361275
Skewness	-0.2055235472
Sum	15555368.54
Variance	0.005173389099
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
19.42121	260	< 0.1%
19.41792	168	< 0.1%
19.4183695	160	< 0.1%
19.42384	152	< 0.1%
19.3739788	143	< 0.1%
19.43403	123	< 0.1%
19.42449	106	< 0.1%
19.36174	98	< 0.1%
19.44631	95	< 0.1%
19.40188	90	< 0.1%
Other values (540181)	801041	95.3%
(Missing)	38084	4.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19.12636062	1	< 0.1%
19.12664586	1	< 0.1%
19.12703559	2	< 0.1%
19.12723891	1	< 0.1%
19.12733	1	< 0.1%
19.12755982	1	< 0.1%
19.12778569	1	< 0.1%
19.12781795	1	< 0.1%
19.1278348	1	< 0.1%
19.12796004	1	< 0.1%

Value	Count	Frequency (%)
19.5833333	1	< 0.1%
19.58232	1	< 0.1%
19.58111	1	< 0.1%
19.5806	1	< 0.1%
19.57955	2	< 0.1%
19.5792784	1	< 0.1%
19.57926981	1	< 0.1%
19.57888	1	< 0.1%
19.57887705	1	< 0.1%
19.57882592	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	df_index	idCarpeta	dia_hechos	Mes_hecho	Año_hecho	FechaHecho	HoraHecho	Delito	CalidadJuridica	Categoria	ColoniaHechos	AlcaldiaHechos	Sexo	Edad	TipoPersona	longitud	latitud
0	0	8324429.0	08	Agosto	2018.0	29/08/2018	43200.0	FRAUDE	OFENDIDO	DELITO DE BAJO IMPACTO	GUADALUPE INN	ALVARO OBREGON	Masculino	62.0	FISICA	-99.18314	19.36125
1	1	8324430.0	12	Diciembre	2018.0	15/12/2018	54000.0	PRODUCCIÓN, IMPRESIÓN, ENAJENACIÓN, DISTRIBUCIÓN, ALTERACIÓN O FALSIFICACIÓN DE TÍTULOS AL PORTADOR, DOCUMENTOS DE CRÉDITO PÚBLICOS O VALES DE CANJE	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	VICTORIA DE LAS DEMOCRACIAS	AZCAPOTZALCO	Femenino	38.0	FISICA	-99.16458	19.47181
2	2	8324431.0	12	Diciembre	2018.0	22/12/2018	55800.0	ROBO A TRANSEUNTE SALIENDO DEL BANCO CON VIOLENCIA	VICTIMA Y DENUNCIANTE	ROBO A CUENTAHABIENTE SALIENDO DEL CAJERO CON VIOLENCIA	COPILCO UNIVERSIDAD ISSSTE	COYOACAN	Masculino	42.0	FISICA	-99.18611	19.33797
3	3	8324435.0	01	Enero	2019.0	04/01/2019	21600.0	ROBO DE VEHICULO DE SERVICIO PARTICULAR SIN VIOLENCIA	VICTIMA Y DENUNCIANTE	ROBO DE VEHÍCULO CON Y SIN VIOLENCIA	AGRÍCOLA PANTITLAN	IZTACALCO	Masculino	35.0	FISICA	-99.05983	19.40327
4	4	8324438.0	01	Enero	2019.0	03/01/2019	72000.0	ROBO DE MOTOCICLETA SIN VIOLENCIA	VICTIMA	ROBO DE VEHÍCULO CON Y SIN VIOLENCIA	PROGRESISTA	IZTAPALAPA	Masculino	NaN	FISICA	-99.06324	19.35480
5	5	8324442.0	10	Octubre	2018.0	12/10/2018	64800.0	PRODUCCIÓN, IMPRESIÓN, ENAJENACIÓN, DISTRIBUCIÓN, ALTERACIÓN O FALSIFICACIÓN DE TÍTULOS AL PORTADOR, DOCUMENTOS DE CRÉDITO PÚBLICOS O VALES DE CANJE	OFENDIDO	DELITO DE BAJO IMPACTO	PUEBLO DE LOS REYES	COYOACAN	Femenino	42.0	FISICA	-99.16016	19.33537
6	6	8324444.0	01	Enero	2019.0	04/01/2019	30600.0	ROBO A TRANSEUNTE DE CELULAR SIN VIOLENCIA	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	TOLTECA	ALVARO OBREGON	Femenino	55.0	FISICA	-99.19472	19.39000
7	8	8324454.0	12	Diciembre	2018.0	27/12/2018	46800.0	PRODUCCIÓN, IMPRESIÓN, ENAJENACIÓN, DISTRIBUCIÓN, ALTERACIÓN O FALSIFICACIÓN DE TÍTULOS AL PORTADOR, DOCUMENTOS DE CRÉDITO PÚBLICOS O VALES DE CANJE	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	BANJIDAL	IZTAPALAPA	Femenino	83.0	FISICA	-99.13696	19.35996
8	9	8324455.0	01	Enero	2018.0	04/01/2018	46800.0	OMISION DE AUXILIO O DE CUIDADO	VICTIMA	DELITO DE BAJO IMPACTO	NaN	VENUSTIANO CARRANZA	Masculino	15.0	FISICA	NaN	NaN
9	10	8324457.0	05	Mayo	2018.0	11/05/2018	36000.0	DESPOJO	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	SANTIAGO ACAHUALTEPEC	IZTAPALAPA	Masculino	45.0	FISICA	-99.00410	19.35325

Last rows

	df_index	idCarpeta	dia_hechos	Mes_hecho	Año_hecho	FechaHecho	HoraHecho	Delito	CalidadJuridica	Categoria	ColoniaHechos	AlcaldiaHechos	Sexo	Edad	TipoPersona	longitud	latitud
840510	845612	9226860.0	06	Junio	2022.0	30/06/2022	36000.0	FRAUDE	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	BUENAVISTA	CUAUHTEMOC	Femenino	NaN	FISICA	-99.151585	19.440587
840511	845613	9226868.0	06	Junio	2022.0	30/06/2022	64800.0	VIOLENCIA FAMILIAR	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	AMPLIACIÃ<U+0093>N PENITENCIARIA	VENUSTIANO CARRANZA	Femenino	61.0	FISICA	-99.116411	19.435591
840512	845614	9226856.0	06	Junio	2022.0	30/06/2022	19200.0	ROBO DE OBJETOS DEL INTERIOR DE UN VEHICULO	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	OBSERVATORIO	MIGUEL HIDALGO	Masculino	62.0	FISICA	-99.189496	19.407119
840513	845615	9226864.0	06	Junio	2022.0	30/06/2022	48600.0	AMENAZAS	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	AMPLIACIÃ<U+0093>N PANAMERICANA	GUSTAVO A MADERO	Masculino	48.0	FISICA	-99.144806	19.478034
840514	845617	9226869.0	05	Mayo	2022.0	26/05/2022	23400.0	FRAUDE	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	VALLEJO	GUSTAVO A MADERO	Femenino	48.0	FISICA	-99.138365	19.466620
840515	845618	9226872.0	06	Junio	2022.0	30/06/2022	70200.0	AMENAZAS	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	ZONA CENTRO	VENUSTIANO CARRANZA	Femenino	31.0	FISICA	-99.122936	19.436282
840516	845619	9226875.0	06	Junio	2022.0	30/06/2022	57600.0	VIOLENCIA FAMILIAR	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	AMPLIACIÃ<U+0093>N ALPES	ALVARO OBREGON	Masculino	32.0	FISICA	-99.211916	19.357075
840517	845620	9226873.0	06	Junio	2022.0	28/06/2022	9720.0	USURPACIÃ<U+0093>N DE IDENTIDAD	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	TEPETONGO	CUAJIMALPA DE MORELOS	Femenino	18.0	FISICA	-99.291582	19.370314
840518	845621	9226876.0	06	Junio	2022.0	30/06/2022	75600.0	AMENAZAS	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	ANAHUAC	MIGUEL HIDALGO	Masculino	32.0	FISICA	-99.173565	19.440914
840519	845622	9226874.0	06	Junio	2022.0	29/06/2022	21180.0	ROBO DE PLACA DE AUTOMOVIL	VICTIMA Y DENUNCIANTE	DELITO DE BAJO IMPACTO	DOCTORES	CUAUHTEMOC	Femenino	44.0	FISICA	-99.146263	19.423728

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Punctuation

Math Symbol

Control

Space Separator

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Math Symbol

Space Separator

Control

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block